This assignment is for ETC5521 Assignment 1 by Team brolga comprising of Hanchen Wang and Jiaying Zhang.
It has been 45 years since the first landline telephone was invented in 1876. The telephone has changed a lot from how it works to how it looks. Today, mobile technology has spread rapidly around the globe and it is estimated that more than 5 billion people have mobile devices, and over half of these connections are smartphones.
“Digital connectivity plays a critical role in bettering lives, as it opens the door to unprecedented knowledge, employment and financial opportunities for billions of people worldwide,” said ITU Secretary-General Houlin Zhao. Because the telephone plays a crucial role in our life, we think it is valuable to analyze it.
This analysis is based on information about mobile and landline phones collected by the ITU (2021) -International Telecommunication Union and would like to analyze the phone subscription trend, percentage and other factors.
Specially:
1.What is the trend in subscription of phone and landline worldwide between 1990 and 2017?
2.What was the growth rate of the subscription of mobile phones in each country from 2015 to 2017 and what was the proportion of the subscription of phone and landline in 2017?
3.What is the regression relationship between phone subscriptions and other variables?
The datasets are downloaded from the Github repository of Tidy Tuesday. Tidy Tuesday (2021) is a weekly data project aimed at the R ecosystem and this report will use datasets adopted by it on November 10, 2020.
There are two datasets provided in the repository and all of them came from an article-“Technology Adoption” which written by Ritchie and Roser (2017) on 2017 OurWorldInData.org.
Tidy Tuesday (2021) only made a few changes to the original data and already can get relatively clean data that can be used for analysis, mainly by matching the time of several original data, screening the data from 1990 to 2017, and adding the corresponding continent of each country.
landline.csv)The dataset about Fixed(landline) telephone subscriptions vs GDP per capita also originated from “Technology Adoption.” It published by (Worldbank 2021 – World Development Indicators)(http://data.worldbank.org/data-catalog/world-development-indicators) and collected by (ITU 2021 - International Telecommunication Union)(https://www.itu.int/en/ITU-D/Statistics/Pages/publications/wtid.aspx). The dataset cover the data about fixed telephone subscriptions and GPD per capita in each country during 1960 and 2017.
Fixed telephone subscriptions refers to the sum of active number of analogue fixed telephone lines, voice-over-IP (VoIP) subscriptions, fixed wireless local loop (WLL) subscriptions, ISDN voice-channel equivalents and fixed public payphones.
landline.csvThis dataset has 6974 number of observations and 7 number of variables. The name, type and description of each variable in landline.csv can be found in the data dictionary below.
| variable | class | description |
|---|---|---|
| entity | character | Country |
| code | character | Country code |
| year | double | Year |
| total_pop | double | Gapminder total population |
| gdp_per_cap | double | GDP per capita, PPP (constant 2011 international $) |
| landline_subs | double | Fixed telephone subscriptions (per 100 people) |
| continent | character | Continent |
Data on fixed telephone lines are derived using administrative data that countries (usually the regulatory telecommunication authority or the Ministry in charge of telecommunications) regularly, and at least annually, collect from telecommunications operators.
Data for this indicator are readily available for approximately 90 percent of countries, either through ITU’s World Telecommunication Indicators questionnaires or from official information available on the Ministry or Regulator’s website. For the rest, information can be aggregated through operators’ data (mainly through annual reports) and complemented by market research reports.
Figure 2.1: Visualise the missing value in landline data
gdp_per_cap and landline_subs, which may have come influence on the results of statistical analysis.mobile.csv)The dataset about Mobilephone subscriptions vs GDP per capita originated from an article-“Technology Adoption.” This dataset was published by (Worldbank 2021 – World Development Indicators)(http://data.worldbank.org/data-catalog/world-development-indicators) and collected by (ITU 2021 - International Telecommunication Union)(https://www.itu.int/en/ITU-D/Statistics/Pages/publications/wtid.aspx). The dataset cover the data about mobilephone subscriptions and GPD per capita in each country from 1960 to 2017.
mobile.csvThis dataset has 6277 number of observations and 7 number of variables. The name, type and description of each variable in mobile.csv can be found in the data dictionary below.
| variable | class | description |
|---|---|---|
| entity | character | Country |
| code | character | Country code |
| year | double | Year |
| total_pop | double | Gapminder total population |
| gdp_per_cap | double | GDP per capita, PPP (constant 2011 international $) |
| mobile_subs | double | Fixed mobile subscriptions (per 100 people) |
| continent | character | Continent |
Mobile cellular telephone subscriptions are subscriptions to a public mobile telephone service that provide access to the PSTN using cellular technology. The indicator includes (and is split into) the number of postpaid subscriptions, and the number of active prepaid accounts (i.e. that have been used during the last three months). The indicator applies to all mobile cellular subscriptions that offer voice communications. It excludes subscriptions via data cards or USB modems, subscriptions to public mobile data services, private trunked mobile radio, telepoint, radio paging and telemetry services.
Data on mobile cellular subscribers are derived using administrative data that countries (usually the regulatory telecommunication authority or the Ministry in charge of telecommunications) regularly, and at least annually, collect from telecommunications operators.
Data for this indicator are readily available for approximately 90 percent of countries, either through ITU’s World Telecommunication Indicators questionnaires or from official information available on the Ministry or Regulator’s website. For the rest, information can be aggregated through operators’ data (mainly through annual reports) and complemented by market research reports.
Figure 2.2: Visualise the missing value in mobile data
gdp_per_cap , total_popand mocile_subs, which may have some influence on the results of statistical analysis.Figure 3.1: Growth rate of the mobile subscription in each country during 2013 and 2017
(Put mouse on each country you can see the detail about country names and the mobilephone subscription 3 years growthrate of them.)
From the figure 3.1 we can see the increase of mobile phone subscriptions in recent years. In the three years from 2015 to 2017, the number of mobile phone subscriptions was not very large on average, staying at around 0. There are even countries like France, Russia and Mexico that have negative growth. On Libreria, which is up -44%, mobile subscriptions are falling fast. But it’s worth noting that the number of mobile subscriptions in Somania and Burma grew by 73% over the same period.
Figure 3.2: Compare proportion of the subscription of phone and landline from 2000 to 2017
As we can see from the animation 3.2, the main trend since 2000 is that the number of fixed-line phones has been decreasing while the number of mobile phones has been increasing. European countries have more fixed-line phones, and more people still use them in the recent past. Most African countries, by contrast, rarely use landlines. This may be because people in European countries used to have landlines, so even as mobile phones became more popular, they still had a large proportion of people using them. However, African countries rarely used landline telephone from the beginning, so with the advent of mobile phone, they did not have the process of landline to mobile phone, and chose mobile phone directly.
Figure 3.3: Proportion of the subscription of phone and landline in 2000 and 2017
And picture 3.3 showed us more detail information, compares the 2000 and 2017 of fixed telephone and mobile phone number in 100, we can see that in most countries the number of fixed phone basically fell sharply only less than 50 fixed phone in 100, on the contrary there are quite a few people have more mobile phone at the same time. It’s worth noting that Monaco has a far higher percentage of fixed-line phones than any other country, while Hong Kong has nearly 2.5 mobile phones per person.
[FILL] Should include at least one plot or numerical summary for each of your questions, that helps the reader arrive at an answer. You should also write paragraphs describing the methods, summaries and findings.
Laura Silver (2021) thematicmapping (2021) Wickham et al. (2021) Wickham and Hester (2020) Wickham (2021) Tierney et al. (2020)